package com.ftg.learn.day15.myframework;

import com.ftg.learn.day15.myframework.annotation.InsertForMyself;
import com.ftg.learn.day15.myframework.annotation.SelectForMyself;

import java.util.List;
import java.util.Map;

/**
 * 描述 sql映射器
 *
 * @author 布衣
 * @date 2024/7/5
 */
public interface DeptMapper {

    @SelectForMyself(value = "select * from dept")
    List<Map<String,Object>> showAll();

    @SelectForMyself(value = "select * from dept where dname = ?")
    List<Map<String,Object>> showAll1(String abc);

    @InsertForMyself("insert into dept(deptno,dname,loc) values(?,?,?)")
    int insert(int deptno,String dname,String loc);
}
